Creating a CSV Report 

In this example, we will use the Employees table within the sample database to create a CSV report.  The table contains the following fields which are all used in the Report query. 

Field name Description
emp_id Employee Number
last_name Employee Last Name
first_name Employee First Name
hire_date Hire Date
salary Salary
dept_id Department ID
location_id Location ID (a department can exist in several locations)
Street_Line1 1st line of address
Street_Line2 2nd line of address
Street_Line3 3rd line of address
city City
state State
zip Zip Code